

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<%
   bean.DataBaseConnection conn = new bean.DataBaseConnection();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <link href='logo_usd.gif' rel='SHORTCUT ICON'/>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Sistem Informasi Akademik</title>
    </head>
    <body background="belakang.jpg">
        <jsp:useBean id="kalk2" scope="session" class="bean.DataBaseConnection"/>
        <jsp:setProperty name="kalk2" property="nim" value="${param.Nim}"/>
        <jsp:setProperty name="kalk2" property="namapanggil" value="${param.Namapanggil}"/>
        <jsp:setProperty name="kalk2" property="namapanjang" value="${param.Namapanjang}"/>
        <jsp:setProperty name="kalk2" property="angkatan" value="${param.Angkatan}"/>
        <jsp:setProperty name="kalk2" property="fakultas" value="${param.Fakultas}"/>
        <jsp:setProperty name="kalk2" property="prodi" value="${param.Prodi}"/>
        <jsp:setProperty name="kalk2" property="ttl" value="${param.Ttl}"/>
        <jsp:setProperty name="kalk2" property="alamat" value="${param.Alamat}"/>
        <jsp:setProperty name="kalk2" property="agama" value="${param.Agama}"/>
        <jsp:setProperty name="kalk2" property="sma" value="${param.Sma}"/>
        <jsp:setProperty name="kalk2" property="namaortu" value="${param.Namaortu}"/>
        <jsp:setProperty name="kalk2" property="alamatortu" value="${param.Alamatortu}"/>
            <table width="55%" align="center" cellspacing="0" cellpadding="4px">
                <style type="text/css">
                    a:link    {color:#485e49}
                    a:visited {color:#485e49}
                    a:hover   {color:black}

                    ul#list-nav {
                        list-style:none;
                        margin:2px;
                        padding:0;
                        width:525px
                    }

                    ul#list-nav li {
                        display:inline
                    }

                    ul#list-nav li a {
                        text-decoration:none;
                        padding:1px 0;
                        width:100px;
                        background:#8B8A83;
                        color:#eee;
                        float:left;
                        text-align:center;
                    }

                    ul#list-nav li a:hover {
                        background:#DEDDDD;
                        color:#000000
                    }


                    ul#list-nav-2 {
                        list-style:none;
                        margin:0px;
                        padding:0;
                        width:525px
                    }

                    ul#list-nav-2 li {
                        display:inline
                    }

                    ul#list-nav-2 li a {
                        text-decoration:none;
                        padding:1px 0;
                        width:100px;
                        background:#EDA62B;
                        color:#000000;
                        float:right;
                        text-align:center;
                    }

                    ul#list-nav-2 li a:hover {
                        background:#EDA62B;
                        color:#FFF
                    }

                    /* manu nav */
                    #topmenu{height:36px; float:right;}
                    #nav li {
                    display: inline;
                    text-align: center;
                    padding-right: 1px;
                    margin-right: 0px;
                    float: left;
                    position:relative;
                    }

                    #nav a {
                    color: #000;
                    float: left;
                    text-decoration: none;
                    font-weight:normal;
                    }

                    #nav a span {
                    border:solid 1px #CF951A;
                    background-color:#DEDDDD; 
                    display: block;
                    padding:8px 18px 10px 18px;
                    }

                    #nav{margin:0px; padding:0px; list-style-type:none;  float:left;  z-index:15; position:relative;}
                    #nav ul{margin:0px; padding:0px; list-style-type:none; z-index:16; position:relative;}
                    #nav li{ position:relative; }
                    #nav li a:hover{color:#FFA201; text-decoration:none}
                    #nav li a.active{color:#FFA201;}

                    #nav ul {
                    display:none;
                    left:0px;
                    position:absolute;
                    top:36px;
                    width:160px;
                    z-index:10;
                    border:solid 1px #CF951A;
                    background-color:#DEDDDD;
                    border-width:1px 1px 1px 1px;
                    padding:0px 10px;                   
                    }
                    
                    #nav li ul a{
                    width:160px;
                    height:auto;
                    float:left;
                    text-align:left;
                    padding:0px 0px 0px 0px;
                    font-size:14px;
                    font-weight:normal;
                    line-height:30px;
                    z-index:10;
                    color:#000;
                    }
                    
                    #nav ul ul{top:auto;border-top:none; border:solid 1px #e6e7df; border-width:1px 1px 1px 1px;}	
                    #nav li ul ul {left:123px; top:0px;}
                    #nav li:hover ul ul, #nav li:hover ul ul ul, #nav li:hover ul ul ul ul{display:none;}
                    #nav li:hover ul, #nav li li:hover ul, #nav li li li:hover ul, #nav li li li li:hover ul{display:block;}
                    #nav li ul a{border-top:none;}
                    
                </style>
    <%         
            String name = request.getParameter("nim");
            String password = request.getParameter("namapanggil");
            
            String query="select nim, namapanggil, namapanjang, angkatan, fakultas, prodi, ttl, alamat, agama, sma, namaortu, alamatortu from profilDB where nim like '%"+kalk2.getNim()+"%' or namapanggil like '%"+kalk2.getNamapanggil()+"%'";           
            java.sql.Statement statement = conn.getConnection().createStatement();
            java.sql.ResultSet result = statement.executeQuery(query);
    %>
    <%           
           if (result.next()){
    %>
                <tr>
                    <td colspan="2" align="left" height="35px">

                    </td>
                    <!--
                    <td colspan="0" align="right" height="35px">
                        <font color="black"><script> var tod=new Date(); var weekday=new Array("Minggu","Senin","Selasa","Rabu","Kamis","Jum'at","Sabtu");
                            var monthname=new Array("Januari","Februari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember");
                            var y = tod.getFullYear();  var m = tod.getMonth(); var d = tod.getDate(); var dow = tod.getDay();   var dispTime = " " + weekday[dow] + ", " + d + " " + monthname[m] + " " + y + "    ";
                            if (dow==0) dispTime= "<font color=black>" + dispTime + "</font>";
                            else if (dow==5) dispTime= "<font color=green>" + dispTime + "</font>";
                            else dispTime= "<font color=black>" + dispTime + "</font>";  document.write(dispTime);</script></font>
                        <br><font color="black"><script>if (tod.getTimezoneOffset() == 0) (a=tod.getTime() + (7*60*60*1000));
                            else (a=tod.getTime()); tod.setTime(a); document.write(" " + ((tod.getHours() < 10) ? "0" : "") + tod.getHours() + ":" + ((tod.getMinutes() < 10) ? "0" : "") + tod.getMinutes() + (" WIB "));
                            </script></font>
                    </td>
                    -->
                </tr>
                <tr>
                    <td colspan="3" align="center" height="8px" bgcolor="#CF951A">

                    </td>
                </tr>
                <tr>
                    <td colspan="3" align="center" height="30px" bgcolor="#F5B835">
                        
                    </td>
                </tr>
                <tr>
                    <td rowspan="3" bgcolor="#F5B835" height="115px" width="150px" valign="top">
                    <center><a href="loginForm.jsp"><img src="logousd2.gif"></a></center>
                    </td>
                </tr>
                <tr>
                    <td colspan="2" align="right" bgcolor="#DEDDDD">
                    <img src="atas1.jpg">
                    </td>
                </tr>
                <tr>
                    <td colspan="2" align="left" height="30px" bgcolor="#F5B835">
                    <div id="topmenu">
                    <ul id="nav">
                        <li><a href="loginForm.jsp"><span>Home</span></a>
                            <ul>
                                <li><a href="blankForm.jsp">Informasi Mahasiswa</a></li>
                                <li><a href="profilForm.jsp">Profil Mahasiswa</a></li>
                                <li><a href="blankForm.jsp">Laporan Pembayaran</a></li>
                                <li><a href="blankForm.jsp">Profil Evaluasi Dosen</a></li>
                            </ul>
                        </li>
                        <li><a href=""><span>Nilai</span></a>
                            <ul>
                                <li><a href="ipsForm.jsp">Indeks Prestasi Semester</a></li>
                                <li><a href="blankForm.jsp">Daftar Hasil Studi</a></li>
                            </ul>
                        </li>
                        <li><a href=""><span>Jadwal</span></a>
                            <ul>
                                <li><a href="jadwalForm.jsp">Jadwal Kuliah Mahasiswa</a></li>
                                <li><a href="blankForm.jsp">Jadwal Ujian Mahasiswa</a></li>
                            </ul>
                        </li>
                        <li><a href=""><span>Informasi</span></a>
                            <ul>
                                <li><a href="presensiForm.jsp">Presensi Kuliah</a></li>
                                <li><a href="blankForm.jsp">Info Akademik Mahasiswa</a></li>
                            </ul>
                        </li>
                        <li><a href="mshloginForm.jsp"><span>Logout</span></a></li>
                    </ul>
                </div>
                    </td>
                </tr>
                <tr>
                    <td colspan="3" align="center" height="12px" bgcolor="#CF951A">
                    <ul id="list-nav-2">
                        
                    </ul>
                    </td>
                </tr>
                <tr>
                    <td colspan="3" align="center" height="8px" bgcolor="#DEDDDD">

                    </td>
                </tr>
                <tr>
                    <td colspan="1" rowspan="1" height="25px" bgcolor="#F5B835">
                    <center><font color="black"><b>Profil Mahasiswa</b></font></center>
                    </td>
                    <td valign="top" rowspan="2" bgcolor="white" height="230px">
                        <center><font color="black" size="5"><strong><p>Profil Mahasiswa</p></strong></font></center>                      
                        <table border="0" align="center">
                                <tr>
                                    <td bgcolor="white"><font border="1"><b>NIM</b></font></td>
                                    <td bgcolor="white"><font border="1">:&emsp;<% out.println(result.getString("nim")); %></font></td></tr>
                                <tr>
                                    <td bgcolor="white"><font border="1"><b>Nama Mahasiswa</b></font></td>
                                    <td bgcolor="white"><font border="1">:&emsp;<% out.println(result.getString("namapanjang")); %></font></td></tr>
                                <tr>
                                    <td bgcolor="white"><font border="1"><b>Angkatan</b></font></td>
                                    <td bgcolor="white"><font border="1">:&emsp;<% out.println(result.getString("angkatan")); %></font></td></tr>
                                <tr>
                                    <td bgcolor="white"><font border="1"><b>Fakultas</b></font></td>
                                    <td bgcolor="white"><font border="1">:&emsp;<% out.println(result.getString("fakultas")); %></font></td></tr>
                                <tr>
                                    <td bgcolor="white"><font border="1"><b>Program Studi</b></font></td>
                                    <td bgcolor="white"><font border="1">:&emsp;<% out.println(result.getString("prodi")); %></font></td></tr>
                                <tr>
                                    <td bgcolor="white"><font border="1"><b>Tempat, Tanggal Lahir</b></font></td>
                                    <td bgcolor="white"><font border="1">:&emsp;<% out.println(result.getString("ttl")); %></font></td></tr>
                                <tr>
                                    <td bgcolor="white"><font border="1"><b>Alamat di Jogja</b></font></td>
                                    <td bgcolor="white"><font border="1">:&emsp;<% out.println(result.getString("alamat")); %></font></td></tr>
                                <tr>
                                    <td bgcolor="white"><font border="1"><b>Agama</b></font></td>
                                    <td bgcolor="white"><font border="1">:&emsp;<% out.println(result.getString("agama")); %></font></td></tr>
                                <tr>
                                    <td bgcolor="white"><font border="1"><b>Asal SMA</b></font></td>
                                    <td bgcolor="white"><font border="1">:&emsp;<% out.println(result.getString("sma")); %></font></td></tr>
                                <tr>
                                    <td bgcolor="white"><font border="1"><b>Nama Orang Tua</b></font></td>
                                    <td bgcolor="white"><font border="1">:&emsp;<% out.println(result.getString("namaortu")); %></font></td></tr>
                                <tr>
                                    <td bgcolor="white"><font border="1"><b>Alamat Orang Tua</b></font></td>
                                    <td bgcolor="white"><font border="1">:&emsp;<% out.println(result.getString("alamatortu")); %></font></td></tr>
                        </table>
                    </td> 
                    <td  bgcolor="#DEDDDD" rowspan="4" width="100px" valign="top">

                    </td>
                </tr>
                <tr>
                    <td  bgcolor="#DEDDDD" width="150px" valign="top">

                    </td>
                </tr>
                <tr>
                    <td colspan="1" align="center" height="30px" bgcolor="#F5B835">

                    </td>
                    <td colspan="1" align="center" height="30px" bgcolor="#DEDDDD">
                        <font size="1">@ 2012 Kantor Sistem Informasi Universitas Sanata Dharma Yogyakarta</font>
                    </td>
                </tr>
            </table>
                <%                                          
            }else
            response.sendRedirect("mshloginForm.jsp?error=yes");
    %>  
    </body>
</html>



